SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
-- =============================================
-- Author:		Khanh.Le
-- Create date: 
-- Description:	
-- =============================================
CREATE PROCEDURE [dbo].[InsertAvailableRoom]
	@hotelId	INT,
	@roomCategoryId	INT,
	@availableCount	INT,
	@fromDate	DATETIME,
	@toDate	DATETIME
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	INSERT INTO MapHotelRoomAvailables
	(
		-- Id -- this column value is auto-generated
		HotelId,
		RoomCategoryId,
		AvailableCount,
		FromDate,
		ToDate
	)
	VALUES
	(
		@hotelId,
		@roomCategoryId,
		@availableCount,
		@fromDate,
		@toDate
	)
	
END
GO
